package net.jalisq;

import net.jalisq.builder.Select;
import net.jalisq.builder.joins.JoinType;
import net.jalisq.builder.joins.On;
import net.jalisq.builder.joins.OnJoinType;
import net.jalisq.builder.joins.UsingJoinType;
import net.jalisq.functions.Equals;
import net.jalisq.functions.Lower;
import test.gen.schema.systemdb_prod;
import test.gen.tables.centralsystem_landscape;
import test.gen.tables.dsssystem;
import test.gen.tables.j2eesystem;
import static net.jalisq.Symbols.*;

public class Tester {
	public static void main(String[] args) {
		System.out.println( 
				select(
						concat(
								lower(j2eesystem.ABAPBackend), 
								lower(j2eesystem.centralInstanceID), 
								j2eesystem.ABAPBackend
							   ).as("hallohallo"),
							   j2eesystem.DBString
							   
					   ).from(systemdb_prod.j2eesystem, systemdb_prod.dsssystem)
					   .JOIN(systemdb_prod.centralsystem_landscape, new On(centralsystem_landscape.description, dsssystem.description))
					   .where( new Equals(lower(j2eesystem.ABAPBackend), lower(j2eesystem.ABAPBackend))).toSQL()
					
					
				);
	}

}
